

namespace ERP_RORZE_ORDER.Common
{

public class OrderConstants
{
	#region Prefix
	public const string Prefix = "ERP_RORZE_ORDER";
	#endregion

	#region Entities
	public class Entities
	{
		#region Currency
		public class Currency
		{
			public const string Name = "Currency";
			public class FieldName 
			{
				public const string ID="ID";
				public const string CurrencyID="CurrencyID";
                public const string CurrencyName = "CurrencyName";
                public const string FullName = "FullName";
			}
		}
		#endregion

		#region Kind
		public class Kind
		{
			public const string Name = "Kind";
			public class FieldName
			{
				public const string ID="ID";
				public const string KindID="KindID";
                public const string KindName = "KindName";
                public const string FullName = "FullName";
			}
		}
		#endregion

		#region Maker
		public class Maker
		{
			public const string Name = "Maker";
			public class FieldName
			{
				public const string ID="ID";
				public const string MakerID="MakerID";
				public const string EnglishName="EnglishName";
				public const string JapanName="JapanName";
                public const string FullName = "FullName";
			}
		}
		#endregion

		#region Order
		public class Order
		{
			public const string Name = "Order";
			public class FieldName
			{
				public const string ID="ID";
				public const string OrderID="OrderID";
				public const string Date="Date";
				public const string StaffID="StaffID";
                public const string Approved = "Approved";
			}
		}
		#endregion

		#region OrderDelivery
		public class OrderDelivery
		{
			public const string Name = "OrderDelivery";
			public class FieldName
			{
				public const string ID="ID";
				public const string Date="Date";
				public const string OrderID="OrderID";
				public const string ProductID="ProductID";
				public const string Deadline="Deadline";
				public const string Quantity="Quantity";
				public const string Status="Status";
			}
		}
		#endregion

		#region OrderInput
		public class OrderInput
		{
			public const string Name = "OrderInput";
			public class FieldName
			{
				public const string ID="ID";
				public const string OrderID="OrderID";
				public const string ProductID="ProductID";
				public const string Deadline="Deadline";
				public const string Quantity="Quantity";
				public const string ExchangeRate="ExchangeRate";
				public const string PurchaseID="PurchaseID";
				public const string PGroupID="PGroupID";
				public const string Status="Status";
				public const string Note="Note";
                public const string ArrivedDate = "ArrivedDate";
                public const string Price = "Price";
			}
		}
		#endregion

		#region PGroup
		public class PGroup
		{
			public const string Name = "PGroup";
			public class FieldName
			{
				public const string ID="ID";
				public const string PGroupID="PGroupID";
                public const string PGroupName = "PGroupName";
                public const string FullName = "FullName";
			}
		}
		#endregion

		#region Product
		public class Product
		{
			public const string Name = "Product";
			public class FieldName
			{
				public const string ID="ID";
				public const string ProductID="ProductID";
				public const string ProductName="ProductName";
				public const string EnglishName="EnglishName";
				public const string VietName="VietName";
				public const string JapanName="JapanName";
				public const string Size="Size";
				public const string MakerID="MakerID";
				public const string ProductGroupID="ProductGroupID";
				public const string SupplierID="SupplierID";
				public const string KindID="KindID";
				public const string UnitID="UnitID";
				public const string Price="Price";
				public const string CurrencyID="CurrencyID";
                public const string PurposeID = "PurposeID";
                public const string FullName = "FullName";
                public const string MakerName = "MakerName";
                public const string PurposeName = "PurposeName";
                public const string SupplierName = "SupplierName";
                public const string GroupName = "GroupName";
			}
		}
		#endregion

		#region ProductGroup
		public class ProductGroup
		{
			public const string Name = "ProductGroup";
			public class FieldName
			{
				public const string ID="ID";
				public const string GroupID="GroupID";
				public const string GroupName="GroupName";
				public const string Note="Note";
                public const string FullName = "FullName";
			}
		}
		#endregion

		#region Purchaser
		public class Purchaser
		{
			public const string Name = "Purchaser";
			public class FieldName
			{
				public const string ID="ID";
				public const string PurchaseID="PurchaseID";
                public const string PurchaseName = "PurchaseName";
                public const string FullName = "FullName";
			}
		}
		#endregion

		#region Purpose
		public class Purpose
		{
			public const string Name = "Purpose";
			public class FieldName
			{
				public const string ID="ID";
				public const string PurposeID="PurposeID";
				public const string VietName="VietName";
				public const string EnglishName="EnglishName";
                public const string JapanName = "JapanName";
                public const string FullName = "FullName";
			}
		}
		#endregion

		#region Supplier
		public class Supplier
		{
			public const string Name = "Supplier";
			public class FieldName
			{
				public const string ID="ID";
				public const string SupplierID="SupplierID";
				public const string SupplierName="SupplierName";
                public const string Note = "Note";
                public const string FullName = "FullName";
			}
		}
		#endregion

		#region Unit
		public class Unit
		{
			public const string Name = "Unit";
			public class FieldName
			{
				public const string ID="ID";
				public const string UnitID="UnitID";
                public const string UnitName = "UnitName";
                public const string FullName = "FullName";
			}
		}
		#endregion

	}
	#endregion

    #region Stored Procedure
    public class StoreProcedure
    {

        public class FieldName
        {

        }

        #region Basic items
        public class Product
        {
            public const string GetAll = "Sp_243_Product_GetAll";
            public const string GetOne = "Sp_243_Product_GetOne";
            public const string Insert = "Sp_243_Product_Insert";
            public const string Update = "Sp_243_Product_Update";
            public const string Delete = "Sp_243_Product_Delete";
            public const string GetAllFullName = "Sp_243_Product_GetAllFullName";
        }

        public class ProductGroup
        {
            public const string GetAll = "Sp_243_ProductGroup_GetAll";
            public const string GetOne = "Sp_243_ProductGroup_GetOne";
            public const string Insert = "Sp_243_ProductGroup_Insert";
            public const string Update = "Sp_243_ProductGroup_Update";
            public const string Delete = "Sp_243_ProductGroup_Delete";
            public const string GetAllFullName = "Sp_243_ProductGroup_GetAllFullName";
        }

        public class Currency
        {
            public const string GetAll = "Sp_243_Currency_GetAll";
            public const string GetOne = "Sp_243_Currency_GetOne";
            public const string Insert = "Sp_243_Currency_Insert";
            public const string Update = "Sp_243_Currency_Update";
            public const string Delete = "Sp_243_Currency_Delete";
            public const string GetAllFullName = "Sp_243_Currency_GetAllFullName";
        }

        public class Kind
        {
            public const string GetAll = "Sp_243_Kind_GetAll";
            public const string GetOne = "Sp_243_Kind_GetOne";
            public const string Insert = "Sp_243_Kind_Insert";
            public const string Update = "Sp_243_Kind_Update";
            public const string Delete = "Sp_243_Kind_Delete";
            public const string GetAllFullName = "Sp_243_Kind_GetAllFullName";
        }

        public class Unit
        {
            public const string GetAll = "Sp_243_Unit_GetAll";
            public const string GetOne = "Sp_243_Unit_GetOne";
            public const string Insert = "Sp_243_Unit_Insert";
            public const string Update = "Sp_243_Unit_Update";
            public const string Delete = "Sp_243_Unit_Delete";
            public const string GetAllFullName = "Sp_243_Unit_GetAllFullName";
        }

        public class PGroup
        {
            public const string GetAll = "Sp_243_PGroup_GetAll";
            public const string GetOne = "Sp_243_PGroup_GetOne";
            public const string Insert = "Sp_243_PGroup_Insert";
            public const string Update = "Sp_243_PGroup_Update";
            public const string Delete = "Sp_243_PGroup_Delete";
            public const string GetAllFullName = "Sp_243_PGroup_GetAllFullName";
        }

        public class Purchaser
        {
            public const string GetAll = "Sp_243_Purchaser_GetAll";
            public const string GetOne = "Sp_243_Purchaser_GetOne";
            public const string Insert = "Sp_243_Purchaser_Insert";
            public const string Update = "Sp_243_Purchaser_Update";
            public const string Delete = "Sp_243_Purchaser_Delete";
            public const string GetAllFullName = "Sp_243_Purchaser_GetAllFullName";
        }

        public class Order
        {
            public const string GetAll = "Sp_243_Order_GetAll";
            public const string GetOne = "Sp_243_Order_GetOne";
            public const string Insert = "Sp_243_Order_Insert";
            public const string Update = "Sp_243_Order_Update";
            public const string Delete = "Sp_243_Order_Delete";
        }

        public class Purpose
        {
            public const string GetAll = "Sp_243_Purpose_GetAll";
            public const string GetOne = "Sp_243_Purpose_GetOne";
            public const string Insert = "Sp_243_Purpose_Insert";
            public const string Update = "Sp_243_Purpose_Update";
            public const string Delete = "Sp_243_Purpose_Delete";
            public const string GetAllFullName = "Sp_243_Purpose_GetAllFullName";
        }

        public class OrderInput
        {
            public const string GetAll = "Sp_243_OrderInput_GetAll";
            public const string GetAllExpired = "Sp_243_OrderInput_GetAllExpired";
            public const string GetOne = "Sp_243_OrderInput_GetOne";
            public const string GetOneById = "Sp_243_OrderInput_GetOneByID";
            public const string Insert = "Sp_243_OrderInput_Insert";
            public const string Update = "Sp_243_OrderInput_Update";
            public const string UpdateByOrder = "Sp_243_OrderInput_UpdateByOrder";
            public const string Delete = "Sp_243_OrderInput_Delete";
        }

        public class OrderDelivery
        {
            public const string GetAll = "Sp_243_OrderDelivery_GetAll";
            public const string GetOne = "Sp_243_OrderDelivery_GetOne";
            public const string Insert = "Sp_243_OrderDelivery_Insert";
            public const string Update = "Sp_243_OrderDelivery_Update";
            public const string Delete = "Sp_243_OrderDelivery_Delete";
        }
        
        public class Supplier
        {
            public const string GetAll = "Sp_243_Supplier_GetAll";
            public const string GetOne = "Sp_243_Supplier_GetOne";
            public const string Insert = "Sp_243_Supplier_Insert";
            public const string Update = "Sp_243_Supplier_Update";
            public const string Delete = "Sp_243_Supplier_Delete";
            public const string GetAllFullName = "Sp_243_Supplier_GetAllFullName";
        }

        public class Maker
        {
            public const string GetAllFullName = "Sp_243_Maker_GetAllFullName";
            public const string GetAll = "Sp_243_Maker_GetAll";
            public const string GetOne = "Sp_243_Maker_GetOne";
            public const string Insert = "Sp_243_Maker_Insert";
            public const string Update = "Sp_243_Maker_Update";
            public const string Delete = "Sp_243_Maker_Delete";
        }

        #endregion

        public class Report
        {
            public const string QTheoDoiDatHang = "Sp_243_Rpt_QTheoDoiDatHang";
            public const string QHangchuave = "Sp_243_Rpt_QHangchuave";
            public const string QDatHangDetails = "Sp_243_Rpt_QDatHangDetails";
            public const string QMonthlyThanhToan_hang = "Sp_243_Rpt_QMonthlyThanhToan_hang";
            public const string QMonthlyDatHangBophanDetails_Crosstab = "Sp_243_Rpt_QMonthlyDatHangBophanDetails_Crosstab";
        }

    }
    #endregion

    #region Form Title
    public class Form
    {
        public class MessageBox
        {
            public const string Error = "Error";
            public const string Warning = "Warning";
            public const string Notice = "Notice";
            public const string Message = "Message";
            public const string Confirmation = "Confirmation";
        }

        public class BasicList
        {
            public const string Name = "Basic List";

        }

    }
    #endregion

    #region Form Message
    public class Message
    {
        public const string AddSuccess = "Data added Successfully";
        public const string AddSuccessAndQuestion = "Data added succesfully. Do you want to continue adding data?";
        public const string UpdateSuccessAndQuestion = "Data updated succesfully. Do you want to update again?";
        public const string AddFailed = "An error occurred while inserting the record to database. Please try again.";
        public const string UpdateSuccess = "Update Successfully";
        public const string UpdateFailed = "An error occurred while updating the record to database. Please try again.";
        public const string DeleteQuestion = "Do you want to permanently delete this item(s)?";
        public const string DeleteFailed = "Error occurred when deleting data. Please try again.";
        public const string FormAlreadyOpened = "This form is already opened.";
        public const string TableIsNull = "No data to edit/delete.";
        public const string QuestionUpdateTool = "Are you sure you want to replace the data from {0} into {1}?";
        public const string NoDataToExport = "No data to export.";
        public const string ErrorToExport = "cannot export.";
        public const string ImportSuccessfully = "Import {0} row(s) successfully. Do you want to refresh data now?";
        public const string ImportSuccessfullyLog = "Table [333_Import]: Import {0} row(s) successfully.";
        public const string ImportFailedLog = "Table [333_Import]: Import data failed.\n Message: {0}";
        public const string QuestionOpenFileExport = "Do you want to open the file?";

        public class Product
        {
            public const string ProductIDCantEmpty = "\"Product ID\" cannot be empty.";
            public const string ProductNameCantEmpty = "\"Product Name\" cannot be empty.";
            public const string PriceCantEmpty = "\"Price\" cannot be empty.";
            public const string PriceMustGreaterZero = "\"Price\" must be greater than zero.";
            public const string SizeCantEmpty = "\"Size\" cannot be empty.";
            public const string MakerCantEmpty = "\"Maker\" cannot be empty.";
            public const string ProductGroupCantEmpty = "\"Product Group\" cannot be empty.";
            public const string SupplierCantEmpty = "\"Supplier\" cannot be empty.";
            public const string KindrCantEmpty = "\"Kind\" cannot be empty.";
            public const string UnitCantEmpty = "\"Unit\" cannot be empty.";
            public const string CurrencyCantEmpty = "\"Currency\" cannot be empty.";
            public const string PurposeCantEmpty = "\"Purpose\" cannot be empty.";
            public const string ProductHasExisted = "This \"Product ID\" has existed.";
        }

        public class ProductGroup
        {
            public const string GroupIDCantEmpty = "\"GroupID\" cannot be empty.";
            public const string GroupNameCantEmpty = "\"Group Name\" cannot be empty.";
            public const string GroupIDHasExisted = "\"GroupID\" has existed..";
        }

        public class Supplier
        {
            public const string SupplierIDCantEmpty = "\"SupplierID\" cannot be empty.";
            public const string SupplierNameCantEmpty = "\"Supplier Name\" cannot be empty.";
            public const string SupplierIDHasExisted = "\"SupplierID\" has existed..";
        }

        public class Currency
        {
            public const string CurrencyIDCantEmpty = "\"CurrencyID\" cannot be empty.";
            public const string CurrencyNameCantEmpty = "\"Currency Name\" cannot be empty.";
            public const string CurrencyIDHasExisted = "\"CurrencyID\" has existed..";
        }

        public class Unit
        {
            public const string UnitIDCantEmpty = "\"UnitID\" cannot be empty.";
            public const string UnitNameCantEmpty = "\"Unit Name\" cannot be empty.";
            public const string UnitIDHasExisted = "\"UnitID\" has existed..";
        }

        public class PGroup
        {
            public const string PGroupIDCantEmpty = "\"PGroupID\" cannot be empty.";
            public const string PGroupNameCantEmpty = "\"PGroup Name\" cannot be empty.";
            public const string PGroupIDHasExisted = "\"PGroupID\" has existed..";
        }

        public class Purchaser
        {
            public const string PurchaseIDCantEmpty = "\"PurchaseID\" cannot be empty.";
            public const string PurchaseNameCantEmpty = "\"Purchase Name\" cannot be empty.";
            public const string PurchaseIDHasExisted = "\"PurchaseID\" has existed..";
        }

        public class Order
        {
            public const string OrderIDCantEmpty = "\"OrderID\" cannot be empty.";
            public const string DateCantEmpty = "\"Date\" cannot be empty.";
            public const string StaffCantEmpty = "Please select \"Staff\" .";
            public const string ApprovedCantEmpty = "Please select \"Approved\"";
            public const string OrderIDHasExisted = "\"OrderID\" has existed..";
        }

        public class Purpose
        {
            public const string PurposeIDCantEmpty = "\"PurposeID\" cannot be empty.";
            public const string VietNameCantEmpty = "\"Viet Name\" cannot be empty.";
            public const string PurposeIDHasExisted = "\"PurposeID\" has existed..";
        }

        public class Kind
        {
            public const string KindIDCantEmpty = "\"KindID\" cannot be empty.";
            public const string KindNameCantEmpty = "\"Kind Name\" cannot be empty.";
            public const string KindIDHasExisted = "\"KindID\" has existed..";
        }

        public class Maker
        {
            public const string MakerIDCantEmpty = "\"MakerID\" cannot be empty.";
            public const string EnglishNameCantEmpty = "\"English Name\" cannot be empty.";
            public const string MakerIDHasExisted = "\"MakerID\" has existed..";
        }


        public class OrderInput
        {
            public const string OrderIDCantEmpty = "Please select \"OrderID\".";
            public const string ProductCantEmpty = "Please select \"Product\".";
            public const string ProductInvalid = "Invalid ProductID.";
            public const string DeadlineCantEmpty = "\"Deadline\" cannot be empty.";
            public const string QuantityCantEmpty = "\"Quantity\" cannot be empty.";
            public const string QuantityMustGreaterZero = "\"Quantity\" must be greater than 0.";
            public const string ExchangeRateCantEmpty = "\"Exchange Rate\" cannot be empty.";
            public const string ExchangeRateMustGreaterZero = "\"Exchange Rate\" must be greater than 0.";
            public const string PurchaseCantEmpty = "Please select \"Purchase\".";
            public const string PGroupCantEmpty = "Please select \"PGroup\".";
            public const string WrongArrivedDate = "Wrong Arrived Date.";
            public const string StatusCantEmpty = "\"Status\" cannot be empty.";
        }

        public class OrderDelivery
        {
            public const string DateCantEmpty = "\"Date\" cannot be empty.";
            public const string OrderIDCantEmpty = "\"OrderID\" cannot be empty.";
            public const string ProductCantEmpty = "\"Product\" cannot be empty.";
            public const string DeadlineCantEmpty = "\"Deadline\" cannot be empty.";
            public const string QuantityCantEmpty = "\"Quantity\" cannot be empty.";
            public const string QuantityMustGreaterZero = "\"Quantity\" must be greater than 0.";
            public const string StatusCantEmpty = "\"Status\" cannot be empty.";
        }


    }
    #endregion

    #region Configuration
    public class Configuration
    {
        public class FilterFile
        {
            public const string Excel = "Excel 2007-2013|*.xlsx|Excel 97-2003 (*.xls)|*.xls";
        }

        public class ReportName
        {
            public const int QTheoDoiDatHang = 1;
            public const int QHangchuave = 2;
            public const int QDatHangDetails = 3;
            public const int QMonthlyThanhToan_hang = 4;
            public const int QMonthlyDatHangBophanDetails_Crosstab = 5;


        }
        
        public class DateRangeTitle
        {
            public const string SixMonths = "6 Months";
            public const string OneYear = "1 Year";
            public const string TwoYears = "2 Years";
            public const string AllTime = "All time";

        }

    }
    #endregion


}
}
